from app.utils.database import create_connection

# 连接数据库并检查角色表数据
conn = create_connection()
cursor = conn.cursor()
cursor.execute('SELECT * FROM probenicedb.roles')
roles = cursor.fetchall()
print('Roles in database:')
for role in roles:
    print(f'  - ID: {role[0]}, Name: {role[1]}, Description: {role[2]}')
cursor.close()
conn.close()